﻿CREATE TABLE [dbo].[MemberAddresses] (
    [AddressId]        INT            IDENTITY (1, 1) NOT NULL,
    [MemberId]         INT            NOT NULL,
    [Street]           NVARCHAR (256) COLLATE Arabic_CI_AS NULL,
    [BuildingNumber]   NCHAR (10)     COLLATE Arabic_CI_AS NULL,
    [FloorNumber]      NCHAR (10)     COLLATE Arabic_CI_AS NULL,
    [AppartmentNumber] NCHAR (10)     COLLATE Arabic_CI_AS NULL,
    [ZipCode]          NCHAR (10)     COLLATE Arabic_CI_AS NULL,
    [Directions]       NVARCHAR (MAX) COLLATE Arabic_CI_AS NOT NULL
);

